﻿// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_QC_IPQC_ORDER
// * CreateDate    : 2012/5/8 13:31:23
// * Creater       : CodeSmith
// * LastChangeDate: 2012/5/8 13:31:23
// * LastChanger   : 2012/5/8 13:31:23
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
    [Serializable]
    public partial class QcIpqcOrderTable : TableInfo
    {
        public const string C_TableName = "QC_IPQC_ORDER";

        public const string C_ORDER_ID = "ORDER_ID";
        public const string C_PROD_PLAN_ORDER_ITEM_ID = "PROD_PLAN_ORDER_ITEM_ID";
        public const string C_PRODUCT_TECHNIC_ID = "PRODUCT_TECHNIC_ID";
        public const string C_ORDER_CODE = "ORDER_CODE";
        public const string C_STATUS = "STATUS";
        public const string C_CHECK_TYPE = "CHECK_TYPE";
        public const string C_SAMPING_PARAMETERS_ID = "SAMPING_PARAMETERS_ID";
        public const string C_CHECK_QTY = "CHECK_QTY";
        public const string C_NG_QTY = "NG_QTY";
        public const string C_RESULT_TAG = "RESULT_TAG";
        public const string C_CREATE_DATE = "CREATE_DATE";
        public const string C_CREATE_BY = "CREATE_BY";
        public const string C_LAST_MODIFIED_DATE = "LAST_MODIFIED_DATE";
        public const string C_LAST_MODIFIED_BY = "LAST_MODIFIED_BY";
        public const string C_APPROVED_DATE = "APPROVED_DATE";
        public const string C_APPROVED_BY = "APPROVED_BY";
        public const string C_REMARK = "REMARK";
        public const string C_CUSTOM_DEFINE1 = "CUSTOM_DEFINE1";

        public QcIpqcOrderTable()
        {
            _tableName = "QC_IPQC_ORDER";
        }

        protected static QcIpqcOrderTable _current;
        public static QcIpqcOrderTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }

        private static void Initial()
        {
            _current = new QcIpqcOrderTable();

            _current.Add(C_ORDER_ID, new ColumnInfo(C_ORDER_ID, "OrderId", true, typeof(string)));
            _current.Add(C_PROD_PLAN_ORDER_ITEM_ID, new ColumnInfo(C_PROD_PLAN_ORDER_ITEM_ID, "ProdPlanOrderItemId", false, typeof(string)));
            _current.Add(C_PRODUCT_TECHNIC_ID, new ColumnInfo(C_PRODUCT_TECHNIC_ID, "ProductTechnicId", false, typeof(string)));
            _current.Add(C_ORDER_CODE, new ColumnInfo(C_ORDER_CODE, "OrderCode", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS, "Status", false, typeof(string)));
            _current.Add(C_CHECK_TYPE, new ColumnInfo(C_CHECK_TYPE, "CheckType", false, typeof(int)));
            _current.Add(C_SAMPING_PARAMETERS_ID, new ColumnInfo(C_SAMPING_PARAMETERS_ID, "SampingParametersId", false, typeof(string)));
            _current.Add(C_CHECK_QTY, new ColumnInfo(C_CHECK_QTY, "CheckQty", false, typeof(decimal)));
            _current.Add(C_NG_QTY, new ColumnInfo(C_NG_QTY, "NgQty", false, typeof(decimal)));
            _current.Add(C_RESULT_TAG, new ColumnInfo(C_RESULT_TAG, "ResultTag", false, typeof(int)));
            _current.Add(C_CREATE_DATE, new ColumnInfo(C_CREATE_DATE, "CreateDate", false, typeof(DateTime)));
            _current.Add(C_CREATE_BY, new ColumnInfo(C_CREATE_BY, "CreateBy", false, typeof(string)));
            _current.Add(C_LAST_MODIFIED_DATE, new ColumnInfo(C_LAST_MODIFIED_DATE, "LastModifiedDate", false, typeof(DateTime)));
            _current.Add(C_LAST_MODIFIED_BY, new ColumnInfo(C_LAST_MODIFIED_BY, "LastModifiedBy", false, typeof(string)));
            _current.Add(C_APPROVED_DATE, new ColumnInfo(C_APPROVED_DATE, "ApprovedDate", false, typeof(DateTime)));
            _current.Add(C_APPROVED_BY, new ColumnInfo(C_APPROVED_BY, "ApprovedBy", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK, "Remark", false, typeof(string)));
            _current.Add(C_CUSTOM_DEFINE1, new ColumnInfo(C_CUSTOM_DEFINE1, "CustomDefine1", false, typeof(string)));

        }

        public ColumnInfo ORDER_ID
        {
            get { return this[C_ORDER_ID]; }
        }

        public ColumnInfo PROD_PLAN_ORDER_ITEM_ID
        {
            get { return this[C_PROD_PLAN_ORDER_ITEM_ID]; }
        }

        public ColumnInfo PRODUCT_TECHNIC_ID
        {
            get { return this[C_PRODUCT_TECHNIC_ID]; }
        }

        public ColumnInfo ORDER_CODE
        {
            get { return this[C_ORDER_CODE]; }
        }

        public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }

        public ColumnInfo CHECK_TYPE
        {
            get { return this[C_CHECK_TYPE]; }
        }

        public ColumnInfo SAMPING_PARAMETERS_ID
        {
            get { return this[C_SAMPING_PARAMETERS_ID]; }
        }

        public ColumnInfo CHECK_QTY
        {
            get { return this[C_CHECK_QTY]; }
        }

        public ColumnInfo NG_QTY
        {
            get { return this[C_NG_QTY]; }
        }

        public ColumnInfo RESULT_TAG
        {
            get { return this[C_RESULT_TAG]; }
        }

        public ColumnInfo CREATE_DATE
        {
            get { return this[C_CREATE_DATE]; }
        }

        public ColumnInfo CREATE_BY
        {
            get { return this[C_CREATE_BY]; }
        }

        public ColumnInfo LAST_MODIFIED_DATE
        {
            get { return this[C_LAST_MODIFIED_DATE]; }
        }

        public ColumnInfo LAST_MODIFIED_BY
        {
            get { return this[C_LAST_MODIFIED_BY]; }
        }

        public ColumnInfo APPROVED_DATE
        {
            get { return this[C_APPROVED_DATE]; }
        }

        public ColumnInfo APPROVED_BY
        {
            get { return this[C_APPROVED_BY]; }
        }

        public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }

        public ColumnInfo CUSTOM_DEFINE1
        {
            get { return this[C_CUSTOM_DEFINE1]; }
        }



    }
}

